<?php
$pageSize = 3;
$pageIndex = isset($_GET["pageIndex"])?$_GET["pageIndex"]:1;
$pageCount = 0;

$startRow = ($pageIndex-1)*$pageSize;

$sql = "select * from `article`";

$where = "";
$queryTitle = isset($_GET["Title"])?$_GET["Title"]:null;
if($queryTitle){
    $where .= "Title like ('%$queryTitle%')";
}

$queryAuthor = isset($_GET["Author"])?$_GET["Author"]:null;
if($queryAuthor){
    if($where) $where .= " AND ";
    $where .= "AuthorName like ('%$queryAuthor%')";
}
$queryMinDate = isset($_GET["minDate"])?$_GET["minDate"]:null;
if($queryMinDate){
    if($where) $where .=" AND ";
    $where .=" CreateTime <='$queryMinDate'";
}

$queryMaxDate = isset($_GET["maxDate"])?$_GET["maxDate"]:null;
if($queryMinDate){
    if($where) $where .=" AND ";
    $where .=" CreateTime >='$queryMaxDate'";
}
if($where) $sql .= " WHERE $where";

$conn = new mysqli("localhost","root","","myblog");
$rows = [];
$sql .= " LIMiT $startRow,$pageSize";
$rs = $conn->query($sql);
if($conn->error) die($conn->error);
while($row = $rs->fetch_assoc()){
    $rows[] = $row;
}
$rs->close();
$total = 0;
$sql = "SELECT count(Id) as t FROM `article`";

if($where) $sql .= " WHERE $where";
//echo $sql;
$rs = $conn->query($sql);
$total = $rs->fetch_assoc()["t"];
$pageCount = ceil($total/$pageSize);
function makePageUrl($pageIndex){
    $querystring = " pageIndex=$pageIndex";
    foreach($_GET as $k=>$v){
        if($k==="pageIndex") continue;
        $querystring .= "&$k=$v";
    }
    return $querystring;
}
?>


<!DOCTYPE html>
<html>
        <head>
            <meta http-equiv="content-type" content="text/html;charset=utf8"/>
            <title>第一个网页</title>
        </head>
        <body>
            <style type="text/css">
        *{
            font-size: 14px;
            padding: 0;
            margin: 0;
        }
        table{
            border-collapse: collapse;
            background-color: #eee;
            border: 1px solid #666;
            width: 64%;
        }
        table td,table th{
            padding: 6;
            border-collapse: collapse;
            border: 1px solid #ccc;

        }
        table th{
            background-color: #333;
            color: #eee;
        }
        table th div.title{
            width: 40px;
        }
        .filter{
            color: blue;
            margin: 10px 0px;
        }

        </style>
            <h3>文章列表</h3>
            <a href="add.php">新建文章</a>
            <input type="text" name="Title" id="keyword" value="" />
            <script type="text/javascript">
            document.getElementById("keyword").onblur = function(){
                var key = document.getElementById("keyword").value;
            }
            function searchkey(key,node){
                if(!node)node = document.body;
                for(let i=0,j=node.childNodes.length;i<j;i++){
                    let child = node.childNodes[i];
                    let val = child.nodeValue;
                    if(!val){
                        if(child.childNodes && child.childNodes.length){
                            searchkey(key, child);
                        }else continue;
                    }else {
                        var hasKey = val.indezOf(key)>=0;
                        if(hasKey) node.style.border = "1px solid red";
                    }
                }
            }
            </script>
 <form action="" class="filter" method="GET">
            <span>
                    <label>标题</label>
                    <input type="text" name="Title" id="Title" value="<?=$queryTitle?>" />

            </span>
                <span>
                    <label>作者</label>
                    <input type="text" name="Author" id="Title" value="<?=$queryAuthor?>" />

                </span>
               <span>
                    <label>时间</label>
                    <input type="text" name="minDate" value="<?=$queryMinDate?>"  />
                    -  <input type="text" name="maxDate" value="<?=$queryMaxDate?>"  />

               </span>
                <input type="submit" name="submit" value="搜索"/>
            </form>
            <table border="1">
                <thead>
                    <tr>
                        <th><div class="title">标题</div></th>
                        <th>作者</th>
                        <th>时间</th>
                        <th>操作</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach($rows as $row){?>
                    
                <tr>
                    <td>
                     <?=$row["Title"]?> 
                    </td>
                    <td>
                    <?=$row["AuthorName"]?>
                    </td>
                    <td>
                    <?=$row["UpdateTime"]?><br/>
                    <?=$row["CreateTime"]?>
                    </td>
                    <td>
                        详细 修改 删除
                    </td>
                </tr>
                <?php } ?>
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="4">
                            共<?=$total ?>条记录，共<?=$pageCount?>页当前为<input type='text' value="2" value="<?=$pageIndex?>"/>页,
                            <a href="article_list2.php?<?=makePageUrl(1)?>">首页</a>
                            <?php for($i=1;$i<=$pageCount;$i++){?>
                                <a href="article_list2.php?<?=makePageUrl($i)?>"><?=$i ?></a>

                            <?php } ?>
                            <a href="article_list2.php?<?=makePageUrl($pageCount)?>">尾页</a>
                        </td>
                    </tr>
                </tfoot>
            </table>
        </body>
<html>
